clear all
set more off

local path0="C:\Dropbox\GeneticsProject (1)\REStat\round_accepted_replication_files\"

cd "`path0'Workfiles"

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
* EIU study of innovation
insheet using "`path0'Data\Innovation\EIU - innovation - Innovation Transforming the way business creates.txt", clear names tab


label var 	eiu_ppm "EIU: Patents per m"
label var 	eiu_ipi	"EIU: Innovation performance index"
label var 	eiu_ipr	"EIU: Rank"  
label var 	eiu_dii	"EIU: Direct inputs index " 
label var 	eiu_dir	"EIU: Rank " 
label var 	eiu_iei	"EIU: Innovation environment index "
label var 	eiu_ier	"EIU: Rank  "
label var 	eiu_aiei "EIU: Aggregate innovation enablers index  "
label var 	eiu_aier "EIU: Rank  "

foreach var in  eiu_ppm 	eiu_ipi	eiu_ipr	eiu_dii	eiu_dir	eiu_iei	eiu_ier	eiu_aiei eiu_aier {
	rename `var' `var'_2007
}
	

drop country
compress
keep countrycode eiu_ppm

save EIU_innovation_2007, replace


*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
* EIU study of innovation
insheet using "`path0'Data\Innovation\EIU - innovation - Innovation Transforming the way business creates 2009.txt", clear names tab


label var 	eiu_ppm "EIU: Patents per m"
label var 	eiu_ipi	"EIU: Innovation performance index"
label var 	eiu_ipr	"EIU: Rank"  
label var 	eiu_dii	"EIU: Direct inputs index " 
label var 	eiu_dir	"EIU: Rank " 
label var 	eiu_iei	"EIU: Innovation environment index "
label var 	eiu_ier	"EIU: Rank  "
label var 	eiu_aiei "EIU: Aggregate innovation enablers index  "
label var 	eiu_aier "EIU: Rank  "

foreach var in  eiu_ppm 	eiu_ipi	eiu_ipr	eiu_dii	eiu_dir	eiu_iei	eiu_ier	eiu_aiei eiu_aier {
	rename `var' `var'_2009
}
	

drop country
compress
keep countrycode eiu_ppm

save EIU_innovation_2009, replace

